create external table jms_dm.dm_center_stop_time_sum_dt 
(
date_time date COMMENT '日期' ,
agent_name string COMMENT 't代理区' ,
center_name string COMMENT 't中心名称' ,
center_name_code string COMMENT 't中心编码' ,
all_total bigint COMMENT '操作总票数' ,
send_count bigint COMMENT '发件票数' ,
send_avg_time decimal(10,4) COMMENT '发件平均时长' ,
send_tx bigint COMMENT '发件36' ,
sned_fe bigint COMMENT '发件48' ,
send_car_count bigint COMMENT '发车票数' ,
send_car_avg_time decimal(10,4) COMMENT '发车平均时长' ,
send_car_tx bigint COMMENT '发车36' ,
send_car_fe bigint COMMENT '发车48' ,
invalid bigint COMMENT 't有到无发票数或有发无到票数' ,
tx_rate decimal(10,4) COMMENT 't超36小时占比' ,
fe_rate decimal(10,4) COMMENT '超36-48小时占比' ,
up_fe_rate decimal(10,4) COMMENT 't超48小时占比' )
comment '中心停留时长取数,汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_center_stop_time_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');

 ALTER TABLE jms_dm.dm_center_stop_time_sum_dt ADD COLUMNs( agent_code string  COMMENT '代理区code')  cascade;
